Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CDA

With the CDA command, you can identify or change the current directory object for your session.

With an established current directory object, you can specify a file identifier in a DML file access statement without including the name of the directory object. Some examples of file access statements are FILECOPY, FILEMOVE, FILEDELETE, EXPORT, and IMPORT.

Syntax

CDA [directory-alias]

Arguments

directory-alias

  A text expression that specifies the directory object that you want to be the current one for your session.

  When you do not specify this argument, CDA sends the name of the current directory object to the current outfile. When there is no current directory object, the statement reports that fact.

Notes

Specifying a File Identifier with an Established Current Directory Object

The following statement moves the file `log.txt` from your session's current directory object to file `oldlog.txt` in a directory object called `backup`.

    FILECOPY 'log.txt' 'backup/oldlog.txt'

Setting Up a Directory Object

A database administrator must set up a directory object and give you access to it.

Examples

Example 8-41 Specifying the Current Directory Object

The following statement identifies `mydir` as the current directory object.

    CDA 'mydir'

Example 8-42 Obtaining the Current Directory Object

The following statement causes the current directory object to be sent to the current outfile.

    CDA

This statement produces the following output.

    The current directory is MYDIR.